Reorder Attributes (In Database)
(In-Database Processing)
Synopsis
This operator can define the order of the attributes.Description
This operator can define the order of the attributes. It is also possible to define an attribute order for a subset of attributes (regular expressions can be used) and SELECT only them and remove the unmatched attributes. You can also to sort the unmatched attributes and append or prepend them to the specified attribute list.
Input
example set input
Output
- example set output
Parameters
- order mode Ordering method that should be applied.
- attribute ordering Rules to order attributes.
- use regular expressions If checked attribute orders will be evaluated as regular expressions.
- handle unmatched Defines the behavior for unmatched attributes.
- unmatched direction Sort direction for unmatched attribute names.
- sort direction Sort direction for attribute names.